UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sNrG7GUNv7jEEc/29iBZe6xQdV6PuLYzVFCJNMvXQGo='
WHERE
key_id = 'a7586dd9849c3369f3ae11bb6e717857aab42b82c270fbbd0c013e475eaf9abe'
AND (
token = 'sNrG7GUNv7jEEc/29iBZe6xQdV6PuLYzVFCJNMvXQGo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)