UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '029V0cal89l8sc9YANmkFp8WwQnQw3Pjh6VxLOmsLDw='
WHERE
key_id = 'e24983747868e50e11cb3a9fe1a8bd85795896dffae229f0835b1cc9404a2976'
AND (
token = '029V0cal89l8sc9YANmkFp8WwQnQw3Pjh6VxLOmsLDw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)