UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z4cwjUYja6E+erZHzOI03gyA58AU3Wzo5Ie4deLJqhM='
WHERE
key_id = '7dc312b521415e741b988f89c772a9916fdc9ee2d79b1661eb9f36a4fbb7ba46'
AND (
token = 'Z4cwjUYja6E+erZHzOI03gyA58AU3Wzo5Ie4deLJqhM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)