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