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