UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3AublJmZS5JfkNnI7rsP4+/4NdynRSLg6cjWVs78D80='
WHERE
key_id = 'e6686e7ccf696df79c869800490752a7e70a153c3678cddd58e102b200b301d3'
AND (
token = '3AublJmZS5JfkNnI7rsP4+/4NdynRSLg6cjWVs78D80='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)