UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o9wPDBVjzUvjMxiFnvWH3aF+Kr5+MbQOcW0m+uuV1r0='
WHERE
key_id = '305d8c81395170a7e212188b2a098270df201a0593c05a7d15a75c52e5018b47'
AND (
token = 'o9wPDBVjzUvjMxiFnvWH3aF+Kr5+MbQOcW0m+uuV1r0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)