UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6M6ZN0ihOB5tmi1LlyrqbfC6pNpCin9hX5YCFojvShw='
WHERE
key_id = 'd36692342dd24e242b326176b68225371d9329740e00e032e5102e3045b72e7e'
AND (
token = '6M6ZN0ihOB5tmi1LlyrqbfC6pNpCin9hX5YCFojvShw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)