UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oUHNOqnmMsV3ZcVU0asO0+r1Yp13TxDuKnT4aXMSdOE='
WHERE
key_id = '43faf828259c5dd7557c0bb87c98bd11ca7861390c204ce1b9587007b6f4b1ee'
AND (
token = 'oUHNOqnmMsV3ZcVU0asO0+r1Yp13TxDuKnT4aXMSdOE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)