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