UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9UtJjeo7GaZPaceI8IIsCIrEHo/srEb2ruXzWx9uSp8='
WHERE
key_id = '77e803813b95af4ea3e03e2f8f4c3229d89c8030e4fb6b7c850800e5901c390b'
AND (
token = '9UtJjeo7GaZPaceI8IIsCIrEHo/srEb2ruXzWx9uSp8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)