UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b67HsP+hfvM4vu2mz1OzdxLy+ODaIb3niK3cfM53xwY='
WHERE
key_id = '9bb8375963e3ab92b819796d517645ffff0a45c9c068911d4eb03ac7de975b21'
AND (
token = 'b67HsP+hfvM4vu2mz1OzdxLy+ODaIb3niK3cfM53xwY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)