UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XilfWWK2NlYuKfKxBadxbi7ZFyO5bdkzoGGNSyzs9ro='
WHERE
key_id = '03147b5253c564bd5c84724f272aa57c6a2665904392cba6da4dfd0bc9fd0b79'
AND (
token = 'XilfWWK2NlYuKfKxBadxbi7ZFyO5bdkzoGGNSyzs9ro='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)