UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CiJZoMa2U9K3rjmaHi1605D1NiYFKaeJF3Ghso7xuIA='
WHERE
key_id = '6118cf24b7d6a8c796cfa37f65624108fceb211f5b3b244ca44fff7688692fb7'
AND (
token = 'CiJZoMa2U9K3rjmaHi1605D1NiYFKaeJF3Ghso7xuIA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)