UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NG9xSG1oxEmtBYZnX2BP7SXUVbBjV+G/ratla4+1yfM='
WHERE
key_id = '3a2dc0052e4fe0fb9d79231843b90be9403a253303e66ff74fbec88bd5fcd58d'
AND (
token = 'NG9xSG1oxEmtBYZnX2BP7SXUVbBjV+G/ratla4+1yfM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)