UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zS0L0+Oionbj8v002GfyH1m9wdDt6ZB+JBEd3SQZQxI='
WHERE
key_id = '257c3c106d557ebd48f9d6c02d1519274d858b7964be2bb8871a3777828907af'
AND (
token = 'zS0L0+Oionbj8v002GfyH1m9wdDt6ZB+JBEd3SQZQxI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)