UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LrXbXHY67zwoGHgG8MyaUjmnDu5Lb3HK6mNmVWaaOu0='
WHERE
key_id = 'b6fa9896e7072679ab6bcaa4fc8e62227576f5c154b916a1ccef014ee73fd1ff'
AND (
token = 'LrXbXHY67zwoGHgG8MyaUjmnDu5Lb3HK6mNmVWaaOu0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)