UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DTBUEdijlolBo4koFG/nSGG0c+jJlwzR4fiQTUkhU8Q='
WHERE
key_id = 'cf2419b4302eb3b7fa24d61ddfa617bcbc778d7d207f5fe5f9f66d6d6a8eaffa'
AND (
token = 'DTBUEdijlolBo4koFG/nSGG0c+jJlwzR4fiQTUkhU8Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)