UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pS2xRKjTxaQZLh89jkwXVKe4Goy0uzc9qvd+nzCjeSA='
WHERE
key_id = '6f165809f256060cffa64f5a69cf903a71c4a5e0d949de5ba5158439ad13eaed'
AND (
token = 'pS2xRKjTxaQZLh89jkwXVKe4Goy0uzc9qvd+nzCjeSA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)