UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5WbzMZMC0DP8ifKgSLuf4xtqh1YFcWNsYJO6nnrovZ4='
WHERE
key_id = '838540bd2a68f95481af0689e761defccdf90f3733a5cebc608482d3ae77a4b0'
AND (
token = '5WbzMZMC0DP8ifKgSLuf4xtqh1YFcWNsYJO6nnrovZ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)