UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hpKq2gVvOp+8rOKAewbzLkrchRHU0dVLasb2gSzCUpw='
WHERE
key_id = 'e76d074081066422edf220557b2b7a35b68776b34a2bfe04c7c797932b7b8d94'
AND (
token = 'hpKq2gVvOp+8rOKAewbzLkrchRHU0dVLasb2gSzCUpw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)