UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pN7azRORtxOzQ13iVY1Kirp47tUOTAuo9ER33s/1qAc='
WHERE
key_id = 'd575f50fc9f5987e99ecbf4db56f65cdf7c400ef94af29b65929a1abf4134abd'
AND (
token = 'pN7azRORtxOzQ13iVY1Kirp47tUOTAuo9ER33s/1qAc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)