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