UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7GX99LVZ6OqeofHe21oG0TrzwFiI4GJf4zewKid6FP0='
WHERE
key_id = '09fd34d7874fa7de480a802ba6a17427f7d018049d0c3120a974f49ce3a575d9'
AND (
token = '7GX99LVZ6OqeofHe21oG0TrzwFiI4GJf4zewKid6FP0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)