UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o4rB5T4pRJSb1ITmgUaP83hh6zB2XqxGwZeG96vJTsw='
WHERE
key_id = 'c67390210931ab50f298e22a5ba4b049f5bcdf4c9616b801a82a25550dc32a4e'
AND (
token = 'o4rB5T4pRJSb1ITmgUaP83hh6zB2XqxGwZeG96vJTsw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)