UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0eOyO9VmVZnp6SircCwHPBL0Iw7N/gf1wfp67UX5o18='
WHERE
key_id = '3a6d71fc194ec6a0577946c8c5ddab55ed0e5c1bb35bb9a823eb699971beb6dc'
AND (
token = '0eOyO9VmVZnp6SircCwHPBL0Iw7N/gf1wfp67UX5o18='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)