UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Cz2DmreTEDD88zaqajNOxXkImzVAgAiaBc/VsFrkVi0='
WHERE
key_id = 'b199615687e8bf844a85bb70b2597794bceefb25a9169e2eb2a4070faec4d72b'
AND (
token = 'Cz2DmreTEDD88zaqajNOxXkImzVAgAiaBc/VsFrkVi0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)