UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pnk9eJ6IikdfimJVvc/zUO/U6jyz5muIqVJPgXWe2cs='
WHERE
key_id = 'aab4ca5adde598a0011f365b34626967bcd2e4ede6d7d4f822021869afe8185e'
AND (
token = 'pnk9eJ6IikdfimJVvc/zUO/U6jyz5muIqVJPgXWe2cs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)