UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '95NJsdB2D3nmkLoSGNlAGBWTGXieyEBlJMZwVyyBkr8='
WHERE
key_id = '80e78201aa8cacf33ce602a268891d506a9c636b666cb98a3c147c5109b5291c'
AND (
token = '95NJsdB2D3nmkLoSGNlAGBWTGXieyEBlJMZwVyyBkr8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)