UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0AG8qEAVWKEXcHx5t9gNhIfNEIDBsaXAtsPHUS/G9TA='
WHERE
key_id = '76d47b91b7610097966e73a5476bf7800fc49d18108402737a57f99008635e8b'
AND (
token = '0AG8qEAVWKEXcHx5t9gNhIfNEIDBsaXAtsPHUS/G9TA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)