UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G6bW2xTooHOPrxKqfpSqGIYFVJ3gi+WYJssYriq6m7Y='
WHERE
key_id = 'c04d0bbe7c769d8bd5cbb7a55a1505c8fb6456bf2bdaef4e1d900c1d2751f156'
AND (
token = 'G6bW2xTooHOPrxKqfpSqGIYFVJ3gi+WYJssYriq6m7Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)