UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3lHVcaK0962pLttoKfLYVlbiwJKNvinABCHsZKIPVME='
WHERE
key_id = '554c171c05c0ca49a68c98f919c5c4e3ae4e6afaa8c633dd500520f743940334'
AND (
token = '3lHVcaK0962pLttoKfLYVlbiwJKNvinABCHsZKIPVME='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)