UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mL47O75caHh5Yo5J0THKMMZbXXT37WltuQMZNNIzT9E='
WHERE
key_id = '0807d5ad7181fe106c7bfb6c78767456de021a2f86326540c65d739124ba2c36'
AND (
token = 'mL47O75caHh5Yo5J0THKMMZbXXT37WltuQMZNNIzT9E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)